import pandas as pd
import numpy as np

tb1 = pd.read_csv('lane1_VGT.csv')
tb2 = pd.read_csv('lane2_VGT.csv')
tb3 = pd.read_csv('lane3_VGT.csv')
tb4 = pd.read_csv('lane4_VGT.csv')
tb5 = pd.read_csv('lane5_VGT.csv')
tb6 = pd.read_csv('lane6_VGT.csv')


d1 = tb1['Velocity'].sum() / 3.6
d2 = tb2['Velocity'].sum() / 3.6
d3 = tb3['Velocity'].sum() / 3.6
d4 = tb4['Velocity'].sum() / 3.6
d5 = tb5['Velocity'].sum() / 3.6
d6 = tb6['Velocity'].sum() / 3.6

distance = np.array([d1, d2, d3, d4, d5, d6])

print(d1, d2, d3, d4, d5, d6)
print(np.std(distance))
